SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrPlazasSF
AS
SELECT     idPlaza AS ID, CUPOF AS Descripcion, CUISE, Organizacion, FechaAlta, FechaBaja, Funcion, Asignatura, Division, Turno, Baja, UltimoDocente, 
                      DuenoActual, Paquete, CargoSalarialDefault, Horas, SubOrganizacion, Presupuesto, RegimenSalarial
FROM         dbo.tb_Plazas
GO
GRANT SELECT ON  [dbo].[vwrPlazasSF] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vwrPlazasSF] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrPlazasSF] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vwrPlazasSF] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwrPlazasSF] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vwrPlazasSF] TO [SoloVer]
GO
